UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '38ciaOGKnWN2hVatip8gV+hE60b7I7FsP3KauYMjPEs='
WHERE
key_id = '50f67fc5e324966f53f5678734fed3c2c21952214b25364ac25c7ddc101f5d74'
AND (
token = '38ciaOGKnWN2hVatip8gV+hE60b7I7FsP3KauYMjPEs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)