UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H84QRoSlVk9aZ3GgvQbljZ0fvTozoSyTO2D/tYdcAQ4='
WHERE
key_id = 'd7c3c4afbc274ceb299fa5d487556acff436d499aea276830927da8d2c24d273'
AND (
token = 'H84QRoSlVk9aZ3GgvQbljZ0fvTozoSyTO2D/tYdcAQ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)