UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DmYnXZ69SKNSt9kYUsj2s8z96dK0YYU+DBa6Y/mBqZs='
WHERE
key_id = 'e9308f9e92e7b79daee80c8fcf4506fbafb2189d9175ef7ad3d31ca1b5182520'
AND (
token = 'DmYnXZ69SKNSt9kYUsj2s8z96dK0YYU+DBa6Y/mBqZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)