UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o/bJolB9ZtFACVpFACoOVUMN6FRfmKWRzlzKLaS1HlU='
WHERE
key_id = 'd9b9b9428e2c7de666a89571509ec9ce01341a44280f3e5a133a29e9e23dc45b'
AND (
token = 'o/bJolB9ZtFACVpFACoOVUMN6FRfmKWRzlzKLaS1HlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)