UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K6AsEXUuqXck1PV6oQnervH+5VqCycENaN6X39eKZyI='
WHERE
key_id = '31e2a52576fb913020fe6a1655c42bd1c152af99ee573a075469dfb9920df7d2'
AND (
token = 'K6AsEXUuqXck1PV6oQnervH+5VqCycENaN6X39eKZyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)