UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G7gpo/a0DkwWihUtW6my9xupqOxNrQPxCyALbz+sUBs='
WHERE
key_id = 'a63923b723be18ee05bf7de8acb6237d8b6038e32ee76f4f714156245a5440a4'
AND (
token = 'G7gpo/a0DkwWihUtW6my9xupqOxNrQPxCyALbz+sUBs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)