UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'De9i8nerKLs0egq0sEiOsPG3jiDzS1ftsTT45OaP8Ek='
WHERE
key_id = '71cd00b34f3ead66dcee544aa53e43befdc2f468b82ec8039357d93994ccc28d'
AND (
token = 'De9i8nerKLs0egq0sEiOsPG3jiDzS1ftsTT45OaP8Ek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)