UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aCAGVB1WEBxnd08ERl42LYf0H7YodWdNSIq5fXwW+Tw='
WHERE
key_id = 'f72249b3b96668b8874c7e12150cc50b878b197f15dc03086a9d7098c82370c5'
AND (
token = 'aCAGVB1WEBxnd08ERl42LYf0H7YodWdNSIq5fXwW+Tw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)