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