UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iobJ58u0i6IAmY3/gaHxbNze9U6TDh9nhnHTJX28mFM='
WHERE
key_id = '77da1fa8a62854944b7cc4557dc2e7ad668aa3ea5dc6f4647c7f0a33a9f123c0'
AND (
token = 'iobJ58u0i6IAmY3/gaHxbNze9U6TDh9nhnHTJX28mFM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)