UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't8516kBlYDdK91g/+BTR+1anqp8hIpgoqKqmHEV/t9M='
WHERE
key_id = 'a9bc52146ecc584e5d60be5371c4180b3da934f5afcec6c7e4aa2e5b89ac66a5'
AND (
token = 't8516kBlYDdK91g/+BTR+1anqp8hIpgoqKqmHEV/t9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)