UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K+hHHk72JGatNDnBnnD9LT/0eINjwYxtmM2nad+969Q='
WHERE
key_id = '1ee9ddbddb9498f418ec91db386129d7792cc8a7a38f118ae91778e4946082f3'
AND (
token = 'K+hHHk72JGatNDnBnnD9LT/0eINjwYxtmM2nad+969Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)