UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8wvVIkjBNPonGFJjgIz1Ce60fXqYD4Q7rXQnMJZRCVs='
WHERE
key_id = '5f7adb30a637c5a005433dcd19d88eea84ed956825bd9d581ec8ee52538ba4da'
AND (
token = '8wvVIkjBNPonGFJjgIz1Ce60fXqYD4Q7rXQnMJZRCVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)