UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tkQllboAksCeWrAn1wi3IgRPp3yB1nVSGzZDVv1ss9w='
WHERE
key_id = 'e0bad0068a8b515d00cedf12b2300b2f6313ce35a23adea7d06c1b33d3e5cfb0'
AND (
token = 'tkQllboAksCeWrAn1wi3IgRPp3yB1nVSGzZDVv1ss9w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)