UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7pm6B3dUaDEb1YHlvewXakp8cq8bAe6Or5+WzjWHjPA='
WHERE
key_id = '585c0524db1cb507e102b6d0b81bd3764badfcb96e6c832396b324839d6b8ed2'
AND (
token = '7pm6B3dUaDEb1YHlvewXakp8cq8bAe6Or5+WzjWHjPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)