UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZffzC386BeCRd1HcVOs6ni0Pyb4kMEJSo2F0QNBAAZ0='
WHERE
key_id = '51a3612b6cf489b803775cc132b482b3dc18801d55bbdfc1e57ee45fdfa6acbe'
AND (
token = 'ZffzC386BeCRd1HcVOs6ni0Pyb4kMEJSo2F0QNBAAZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)