UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ptC/CVhA9E6scSs1kCpPI7uSjSDPqasI6vz33SFvB9Y='
WHERE
key_id = '333dee20940c4a27f7472d60a7ddc732bf334d3fbe179011238066928f42d310'
AND (
token = 'ptC/CVhA9E6scSs1kCpPI7uSjSDPqasI6vz33SFvB9Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)