UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'clNYVnit0uLjVqgaZrphuvjIiASer9KEU/rjpn+FLAE='
WHERE
key_id = 'cadd517c0e307218ee4c1bc7c3cbd55626aa58e27de012bb1bad2c696e7e62b4'
AND (
token = 'clNYVnit0uLjVqgaZrphuvjIiASer9KEU/rjpn+FLAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)