UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W+6aygUdKiIciDYs5fMJggyt8ziLBOG/i8hRo7c/XgY='
WHERE
key_id = '9e64fe945729155e012e4d1e3e578250f230f74f98d475bc9791e2a0857d45e4'
AND (
token = 'W+6aygUdKiIciDYs5fMJggyt8ziLBOG/i8hRo7c/XgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)