UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'al4iLG/zlZAsxQYOCElLSEAu9SnoWBetVp8eYzG4qLw='
WHERE
key_id = '46b22933f4346d5ff4d949a5033f8feaf23a76d87496c53d06f9cce28865c462'
AND (
token = 'al4iLG/zlZAsxQYOCElLSEAu9SnoWBetVp8eYzG4qLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)