UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/2hmGfDspUfreVlnY+awFff3hmMHdI1DfiZhZCg+bkQ='
WHERE
key_id = 'b8c176278cc3313570fe3e4ddfdb0e5153bcf8df4d2fd59ae59008fc342c2bb9'
AND (
token = '/2hmGfDspUfreVlnY+awFff3hmMHdI1DfiZhZCg+bkQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)