UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xAySlfoHifQfcgRP1fdwdcW7j211NRGqZhenn+LZkhM='
WHERE
key_id = '2dcc187048f08f1bf4951f24a1da79a4c6b96b3124a89c98f2e73a7f2138b38e'
AND (
token = 'xAySlfoHifQfcgRP1fdwdcW7j211NRGqZhenn+LZkhM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)