UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '99jfDJciarDI5wlws3iN58aeRtdAqsujkBl7FOQw8Ak='
WHERE
key_id = 'dfd086e52b9bc21539fbfaf310f047c08970dedfd6bf49abb0b1bfdd7cc66c62'
AND (
token = '99jfDJciarDI5wlws3iN58aeRtdAqsujkBl7FOQw8Ak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)