UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QTXlCthqAm6mQcI7CKPY3dclYwZQ7v2LY6e1F9xsgCo='
WHERE
key_id = 'a8e3844abce10f56f7d179b27bee63d7717a6727e4b84722f238c894701ad3c3'
AND (
token = 'QTXlCthqAm6mQcI7CKPY3dclYwZQ7v2LY6e1F9xsgCo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)