UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6k1tYxo9NkxeGHDF18juyBauUMF0/yorvVyjzE2DL40='
WHERE
key_id = '33b7937aeb99d778838a5cf61ad71b4f8e433840e597556f4e22ab834772460b'
AND (
token = '6k1tYxo9NkxeGHDF18juyBauUMF0/yorvVyjzE2DL40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)