UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rE/Ro2rrVllvAFSVmanrtOXF9or72wz+H/a4o/MIjUI='
WHERE
key_id = 'adab2dc1acf35c59983a45dad065be7f624cde5ba0597bc9ae4cf86784bf3a47'
AND (
token = 'rE/Ro2rrVllvAFSVmanrtOXF9or72wz+H/a4o/MIjUI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)