UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jfoTcVM16Opy4l6alZg86Aq5MJJQd+hei2wMLr9nam4='
WHERE
key_id = 'd78a7adada58def2f76e728bc6dd6f510eacc9327a6cfcdbd72d8351b6b0ff0c'
AND (
token = 'jfoTcVM16Opy4l6alZg86Aq5MJJQd+hei2wMLr9nam4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)