UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hcQqqKISdZOFWBb/bym/cYCuRtjSCLdmbu/2RIMrDGU='
WHERE
key_id = '7d7335aa508d3e776973f3100103570a4b14b832e0be2a16f523d2badf07f78a'
AND (
token = 'hcQqqKISdZOFWBb/bym/cYCuRtjSCLdmbu/2RIMrDGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)