UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7r9rXcOSRqi7Z9a0P+FjMa27IN3gMizBBCUkumfM7VQ='
WHERE
key_id = '319567c1a683694e0dfcd9ab7a5d45d684b61563d03779d1aabf353394bbc120'
AND (
token = '7r9rXcOSRqi7Z9a0P+FjMa27IN3gMizBBCUkumfM7VQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)