UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iWubyvV7K0O/dmXKsIBE3DoflMYJUYkEmod2V/u9zfo='
WHERE
key_id = '16c944307b4a6b5c4d097b7d92281580912bd43f1d131eb3fefae527e0d8e4a6'
AND (
token = 'iWubyvV7K0O/dmXKsIBE3DoflMYJUYkEmod2V/u9zfo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)