UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rWXsy0UWj9fu27DfvOEX3wpwFUE4zxGO59xEF7SYviM='
WHERE
key_id = '9e691db5259e979a3f94d06f8487f68f1fb232fb78d4d82ac70c6fc6dc7465fe'
AND (
token = 'rWXsy0UWj9fu27DfvOEX3wpwFUE4zxGO59xEF7SYviM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)