UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BMMbezqY90d8i8QkLmmylii0/KCSPamUvo4/TjIhS7s='
WHERE
key_id = 'a8b58ea2969f14d39dbfc84a38e74215aac09f80cabad67bbe0ef153ec62591e'
AND (
token = 'BMMbezqY90d8i8QkLmmylii0/KCSPamUvo4/TjIhS7s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)