UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a1cpieXW9czWq90tYPlAX3TgYY/IbENUYkuAma8tja8='
WHERE
key_id = 'ae3bebf247a5adf45e8bc75f8652a43d7a6b7724343184b9e7e451e1dda258dc'
AND (
token = 'a1cpieXW9czWq90tYPlAX3TgYY/IbENUYkuAma8tja8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)