UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2EWKq1WUg2yBj6+lfuPIZKO0Wrp04JJftw5o+EjlJDs='
WHERE
key_id = 'd94e7968ca90300e02da4b23afbd0528f78ed158e00c8e8d46eb960f8634cede'
AND (
token = '2EWKq1WUg2yBj6+lfuPIZKO0Wrp04JJftw5o+EjlJDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)